home *** CD-ROM | disk | FTP | other *** search
Text File | 1991-08-31 | 114.3 KB | 3,363 lines |
-
-
-
-
-
-
-
-
-
- PopDBF (tm)
- "Instant Access to X-Base Files"
-
-
-
-
-
-
-
-
-
-
-
- Version 4.0
-
-
-
-
-
-
-
-
-
-
- User's Manual
-
-
-
-
-
-
-
-
-
-
-
-
- _______
- ____|__ | (R)
- --| | |------------------
- | O___|__ | Association of
- | | |_| Shareware
- |__| O | Professionals
- -----| | |--------------------
- |___|___| MEMBER
-
-
-
- Copyright (c) 1989-1991 Bowen Software, All Rights Reserved
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Table of Contents
-
-
-
-
- 1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . 1
- 1.1 Overview of PopDBF . . . . . . . . . . . . . . . . . 1
- 1.2 Limitations . . . . . . . . . . . . . . . . . . . . . 3
- 1.3 Cautions . . . . . . . . . . . . . . . . . . . . . . 4
- 1.4 Registration . . . . . . . . . . . . . . . . . . . . 5
- 1.4.1 How to Register . . . . . . . . . . . . . . . 5
- 1.4.2 Registration Benefits . . . . . . . . . . . . 6
- 1.5 What is "Shareware" . . . . . . . . . . . . . . . . . 6
- 1.6 ASP Ombudsman Information . . . . . . . . . . . . . . 7
- 1.7 Technical Support . . . . . . . . . . . . . . . . . . 8
- 1.8 Trademark Acknowledgements . . . . . . . . . . . . . 9
- 1.9 License Agreement, Disclaimer and Warranty . . . . . 9
- 1.9.1 Shareware Version License . . . . . . . . . . 9
- 1.9.2 Registered Version License . . . . . . . . . . 10
- 1.9.3 Warranty . . . . . . . . . . . . . . . . . . . 10
-
- 2 Getting Started . . . . . . . . . . . . . . . . . . . . . . 11
- 2.1 Installing PopDBF . . . . . . . . . . . . . . . . . . 11
- 2.2 Executing PopDBF . . . . . . . . . . . . . . . . . . 11
- 2.2.1 Running PopDBF in Memory Resident Mode . . . . 11
- 2.2.2 Running PopDBF in Non-Resident Mode . . . . . 12
- 2.3 Modifying AUTOEXEC.BAT to Load PopDBF . . . . . . . . 12
- 2.4 Removing PopDBF from Memory . . . . . . . . . . . . . 13
- 2.5 How to Invoke PopDBF (Using the "Hotkey") . . . . . . 13
- 2.6 Command Line Options . . . . . . . . . . . . . . . . 13
- /A<A|B|E|S> Default action . . . . . . . . . . . . 14
- /C<C|M|O> Color scheme . . . . . . . . . . . . . 14
- /D<dir> Initial PopDBF Directory . . . . . . . 14
- /E<size> Edit buffer of size bytes . . . . . . 15
- /F<num> Maximum of num fields . . . . . . . . 15
- /G<num> Maximum of num files . . . . . . . . . 15
- /H Command line syntax and options . . . 16
- /I Ignore hotkey, toggles on and off . . 16
- /L<dir> Directory where master .FRQ file is
- located . . . . . . . . . . . . . . . 16
- /[!]P[file] Use "Pass-Thru" non-resident mode . . 16
- /R<size> Read buffer of size bytes . . . . . . 17
- /S<D|E|N> Swap to Disk|EMS|None . . . . . . . . 17
- /T<B,C,I,V,W,Z>
- Toggle indicator defaults . . . . . . . . . . . 18
- /U Uninstall (remove) from memory . . . . 19
- /X<file> File name for swapping to Disk . . . . 19
- /Y<file> Initial PopDBF File . . . . . . . . . 20
-
- i
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Table of Contents
-
-
-
- 3 Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
- 3.1 Generic Help (Alt-F1) . . . . . . . . . . . . . . . . 21
- 3.2 Context Sensitive Help (F1) . . . . . . . . . . . . . 21
-
- 4 Alt Menu (Alt) . . . . . . . . . . . . . . . . . . . . . . . 22
- 4.1 Alt Action Keys . . . . . . . . . . . . . . . . . . . 22
- 4.2 Alt Toggle Keys . . . . . . . . . . . . . . . . . . . 23
- 4.3 Toggle Indicator Summary . . . . . . . . . . . . . . 24
-
- 5 Cursor and Lite-Bar Movement . . . . . . . . . . . . . . . . 25
- 5.1 The "Wordstar" Diamond . . . . . . . . . . . . . . . 25
-
- 6 Pick File (Alt-P) . . . . . . . . . . . . . . . . . . . . . 26
- 6.1 Select Directory/File/Index (Enter) . . . . . . . . . 26
- 6.2 Move to Parent Directory (BackSpace) . . . . . . . . 26
- 6.3 Change Directory and/or Drive (F2) . . . . . . . . . 26
- 6.4 Enter A Specific File (F3) . . . . . . . . . . . . . 27
- 6.5 Change File Specification (F4) . . . . . . . . . . . 27
- 6.6 Change Default Action (F5) . . . . . . . . . . . . . 27
- 6.7 Delete File (F6) . . . . . . . . . . . . . . . . . . 28
- 6.8 Move to Current DOS Drive & Directory (F10) . . . . . 28
- 6.9 Frequent Database Access (Alt-1 thru Alt-=) . . . . . 28
- 6.10 Show Names of Frequently Accessed Databases (Ctrl-
- N) . . . . . . . . . . . . . . . . . . . . . . . . . 29
- 6.11 Program Information . . . . . . . . . . . . . . . . . 29
-
- 7 Setup View (Alt-S) . . . . . . . . . . . . . . . . . . . . . 30
- 7.1 Return To Data (Enter) . . . . . . . . . . . . . . . 30
- 7.2 Number/Un-Number Fields (Space) . . . . . . . . . . . 30
- 7.3 Clear Field Numbers (F2) . . . . . . . . . . . . . . 30
- 7.4 Assign a Specific Field Number (F3) . . . . . . . . . 31
- 7.5 Order Fields Using Field Numbers (F4) . . . . . . . . 31
- 7.6 Tag/Un-Tag Field for Exclusive Find (F6) . . . . . . 31
- 7.7 Clear Exclusive Find Tags (F7) . . . . . . . . . . . 31
- 7.8 Copy File Structure (F8) . . . . . . . . . . . . . . 32
- 7.9 Print the File Structure (F9) . . . . . . . . . . . . 32
-
- 8 Browse Records (Alt-B) . . . . . . . . . . . . . . . . . . . 33
- 8.1 Current Record and Delete Status . . . . . . . . . . 33
- 8.2 Toggle Vertical Separator Bars On/Off (Shift-|) . . . 33
- 8.3 Pan the Browse Window (LeftArrow/RightArrow) . . . . 33
- 8.4 View Large Fields (Tab/Shift-Tab) . . . . . . . . . . 33
- 8.5 Zoom the Browse Window (F2) . . . . . . . . . . . . . 33
- 8.6 Goto a Specific Record (F3) . . . . . . . . . . . . . 33
-
- ii
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Table of Contents
-
-
-
- 8.9 Find Text (F7) . . . . . . . . . . . . . . . . . . . 34
- 8.10 Find Next Occurrence of Text (F8) . . . . . . . . . . 35
- 8.11 Print Records (F9) . . . . . . . . . . . . . . . . . 35
- 8.12 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 36
- 8.13 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 36
-
- 9 Edit/Append Records (Alt-E/Alt-A) . . . . . . . . . . . . . 37
- 9.1 Copy a Record (F2) . . . . . . . . . . . . . . . . . 37
- 9.2 Goto a Specific Record (F3) . . . . . . . . . . . . . 37
- 9.3 Cut Field into Keyboard Paste Buffer (F4) . . . . . . 37
- 9.4 Clear Keyboard Paste Buffer (Shift-F4) . . . . . . . 38
- 9.5 Find Text (F7) . . . . . . . . . . . . . . . . . . . 38
- 9.6 Find Next Occurrence of Text (F8) . . . . . . . . . . 38
- 9.7 Print Records (F9) . . . . . . . . . . . . . . . . . 38
- 9.8 Field Information (F10) . . . . . . . . . . . . . . . 39
- 9.9 Restore Field Data (Ctrl-J) . . . . . . . . . . . . . 39
- 9.10 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 39
- 9.11 System Date (Ctrl-M) . . . . . . . . . . . . . . . . 39
- 9.12 Move to Last Field Position (Ctrl-N) . . . . . . . . 39
- 9.13 Restore Entire Record (Ctrl-O) . . . . . . . . . . . 39
- 9.14 Paste Data (Ctrl-P) . . . . . . . . . . . . . . . . . 40
- 9.15 Abort and Lose Changes (Ctrl-Q/ESCAPE) . . . . . . . 40
- 9.16 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 40
- 9.17 Toggle Verify Mode On/Off (Ctrl-V) . . . . . . . . . 40
- 9.18 Quit and Save Changes (Ctrl-W/Ctrl-End) . . . . . . . 40
- 9.19 Blank Current Field (Ctrl-Y) . . . . . . . . . . . . 40
- 9.20 Blank to End of Field (Ctrl-Delete) . . . . . . . . . 41
- 9.21 Move to End of Data (End) . . . . . . . . . . . . . . 41
- 9.22 Move to First Position (Home) . . . . . . . . . . . . 41
- 9.23 Move Word (Ctrl-LeftArrow/Ctrl-RightArrow) . . . . . 41
- 9.24 Move to First/Last Field (Ctrl-UpArrow/Ctrl-
- DownArrow) . . . . . . . . . . . . . . . . . . . . . 41
- 9.25 Previous Record/Next Record, Same Page (Alt-PgUp/Alt-
- PgDn) . . . . . . . . . . . . . . . . . . . . . . . . 41
-
- 10 Common Questions and Answers . . . . . . . . . . . . . . . 42
-
- 11 Error Messages . . . . . . . . . . . . . . . . . . . . . . 44
-
- 12 Configuring PopDBF . . . . . . . . . . . . . . . . . . . . 46
- 12.1 The Configuration Main Menu . . . . . . . . . . . . 46
- 12.2 Configuring Colors . . . . . . . . . . . . . . . . . 46
- 12.3 Configuring Date/Number Formats . . . . . . . . . . 47
- 12.4 Configuring Main Hotkey . . . . . . . . . . . . . . 47
-
- iii
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Table of Contents
-
-
-
- 12.5 Configuring Paste Options . . . . . . . . . . . . . 48
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- iv
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- 1 Introduction
-
- 1.1 Overview of PopDBF
-
- PopDBF is a pop-up memory resident program that uses only 4K of RAM!
- PopDBF allows you to have "Instant Access" to any dBase compatible
- .DBF database file. This includes, but is not limited to, files
- used by Clipper, dBASE III, dBASE IV, dBXL, FoxBASE+, FoxPro, PC-
- File/db and Quicksilver. The term X-base (which is in the public
- domain) refers to all of the different dialects referred to above.
-
- Memory resident programs, also call TSRs (Terminate Stay Resident),
- are special programs that stay in memory after you run them. To use
- a memory resident program that is in memory, you press the
- designated hotkey. It is this hotkey that causes the program, which
- is hibernating in memory, to "spring" to life and pop-up for you to
- use.
-
- After PopDBF has been loaded, you can access your database files
- from anywhere by pressing the hotkey (the default hotkey is
- Alt-BackSpace). To return to where you came from just press the
- hotkey again. It's that simple!
-
- There are many reasons why PopDBF is the best tool available for
- accessing your database files. Some of the reasons include:
-
- * Faster than using dBASE or a compatible program! You
- don't have to wait while a bulky database program loads
- just to take a quick look at a database file. "Instant
- Access" means just that - INSTANT!
-
- * Easier to use than dBASE! You don't have to know dBASE
- commands. Switching from append to browse to edit is a
- matter of pressing one key!
-
- * Access database files without leaving another application!
- You no longer have to exit your word processor, load your
- database program, look at the database file, exit the
- database program and reload your word processor - just
- press the PopDBF hotkey!
-
- * Cut and Paste information from a database directly into
- another application! Save time typing in name and address
- information to your word processor - let PopDBF do it for
- you!
-
- Copyright (c) 1989-91 Bowen Software Page 1
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- * Searches on a database for ANY text are lightning fast.
- This means you don't have to know what field the text is
- in, PopDBF takes care of it for you!
-
-
- The applications for PopDBF are just as numerous. After just a few
- minutes of using PopDBF you will be thinking up your own ways of how
- to use its many features to improve your productivity. Here are
- just a few examples to spark your creativity.
-
- Great for Anybody who uses a phone:
-
- * Maintain and search a rolodex database of all the people
- you know with their place of business, address(es) and
- phone number(s). This could be applied to any type of
- information you need "instant" access to.
-
- Great for Secretaries and Order Operators
-
- * Take messages for people or log problems with products in
- the field without having to leave the program you are
- currently running.
-
- * Add an order to the order database or search the database
- to see the current status of the order.
-
- Great for Programmers:
-
- * Find out the name, type or length of a field.
-
- * Find out the key used to create any .IDX, .NDX or .NTX
- index file.
-
- * Pack or Zap a database file without having to get out of
- the application to use a database program.
-
- Great for Consultants:
-
- * Print the structure of any or all databases in a directory
- with ease.
-
- * Quickly get into any database to see what the data looks
- like.
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 2
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- PopDBF provides an easy way to move throughout your hard disk(s) and
- networks to find your database files. It also has context sensitive
- help for novice (or forgetful) users, but you probably won't need
- it. PopDBF is that easy to use!
-
-
- You can use PopDBF to:
-
- * pick a database file
- * delete a database file
- * view file structure
- * print file structure
- * append and edit records
- * browse records
- * delete or undelete records
- * print records (design your own mini-report)
- * search for strings anywhere in a database
- * pack or zap a database
- * specify fields and assign their order for the above
- features
- * view index expressions of index files
-
-
- And if you don't feel comfortable using memory resident programs,
- PopDBF has a non-resident "pass-thru" mode so that you can run it
- from the DOS prompt like any other program.
-
- Programmers can even set up macros in some program editors (BOXER,
- Qedit, etc.) to execute PopDBF and have it automatically open the
- database the cursor is positioned on.
-
- PopDBF has four main areas:
-
- 1. Pick File
- 2. Setup View
- 3. Browse Records
- 4. Append/Edit Records
-
- Each of these areas is described more fully below along with the
- actions available from each.
-
-
- 1.2 Limitations
-
- Though PopDBF has many features, it does not do everything, yet!.
-
- Copyright (c) 1989-91 Bowen Software Page 3
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- Currently PopDBF does not do the following:
-
- * view or edit memo fields
- * use index files (it does display the expression used to
- create them)
- * view more than one database file at a time
- * handle database files with more 65,535 records
- * handle fields larger than 254 characters
- * lock individual records in a database on the network
-
- Also, PopDBF is not meant to be a complete replacement for the
- relational database management systems (RDBMS) many people are
- currently using (i.e. dBASE). In some instances the function being
- done with the RDBMS can be fulfilled entirely by PopDBF. However,
- in general PopDBF is meant to enhance those programs and improve
- productivity by providing "instant access" to your valuable database
- information.
-
-
- 1.3 Cautions
-
- When using PopDBF from within any RDBMS or application that allows
- dBASE compatible records to be changed, it is important to remember
- that most of those products do internal record buffering. This
- means that if a record is changed and resides in an internal buffer,
- the change will NOT be reflected when viewed from within PopDBF.
-
- Likewise, if a record is changed in PopDBF while that same record is
- in an internal buffer, the change will be overwritten by the RDBMS
- or application when it closes the file and/or flushes the internal
- buffer.
-
- As a general rule, do not use PopDBF to change records in a database
- that might be opened by an RDBMS or similar application.
-
- It should also be pointed out that because PopDBF does not currently
- use index files, no indexes will be updated. Care should be taken
- when changing databases that have associated indexes which need to
- stay up to date. For these types of databases, as long as you don't
- change key fields (fields used to create an index), add or delete
- records there will be no problem.
-
- Should you need to change information in databases falling into the
- category mentioned above, just make sure that you reindex the
- database.
-
- Copyright (c) 1989-91 Bowen Software Page 4
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- 1.4 Registration
-
- 1.4.1 How to Register
-
- PopDBF is not FREE! You may try it out at no charge for an initial
- trial period to determine if it fits your needs. If you want to
- continue to use PopDBF after the initial trial period you must
- register. This method of software distribution is known as
- Shareware.
-
- The registration fee for a single copy of PopDBF is $35US. All
- checks or money orders must be payable in US dollars. For a
- description of what you get when you register see "Registration
- Benefits" on page 6.
-
- Registration of PopDBF is mandatory for commercial and government
- users.
-
- To register your copy of PopDBF, send your registration fee of $35,
- payable in US funds (see the file ORDER.FRM), to:
-
- Bowen Software
- P.O. Box 2134
- East Peoria, Illinois 61611
-
- You can order by sending check, cash or money order to Bowen
- Software at the address listed above.
-
- You can also register with Master Card, Visa, Amex, or Discover by
- calling (800) 242-4775 or (713) 524-6394 or by FAX to (713) 524-6398
- or by CompuServe Email to 71355,470. THESE NUMBERS ARE FOR ORDERS
- ONLY.
-
- Any questions about the status of the shipment of the order,
- refunds, product details, technical support, volume discounts,
- dealer pricing, site licenses, etc, must be directed to Bowen
- Software at 309-699-0950. You can also mail credit card orders to
- Bowen Software c/o PsL, P.O. Box 35705, Houston, TX 77235-5705.
-
- There is a cash discount, which is waived for credit card orders.
-
- You can also order PopDBF by calling your local software distributor
- (i.e. Computerland, Egghead).
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 5
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- PopDBF must be registered for EACH USER at your site; alternatively,
- contact Bowen Software for current SITE LICENSE information.
-
- It is our desire at Bowen Software that you be completely satisfied
- with our software products and services. To insure this we offer a
- complete money back guarantee!
-
-
- 1.4.2 Registration Benefits
-
- The following benefits apply to all registered users of PopDBf:
-
- * FREE technical support over the phone for at least six
- months.
-
- * Notified of program updates and provided the first update
- absolutely FREE!
-
- * Registered version of PopDBF does NOT contain the
- registration information screen, which pops up on the
- screen twice during each 24 hour period (it does pop up
- when exiting each time if run in Pass-Thru mode).
-
- * FREE introductory subscription to CompuServe Information
- Service - the biggest national BBS! You will receive: a
- private user ID number and Password, a $15 usage credit
- (over 1 hour connect time at 2400 baud), a complimentary
- subscription to CompuServes's monthly computing magazine:
- 'Compuserve'.
-
- * Significant discount on Shareware Magazine where you can
- find out about the best shareware and how to get it.
-
-
- 1.5 What is "Shareware"
-
- "Shareware" is a term used to describe a system for distribution of
- software. Under the shareware concept, software may be freely
- copied and passed along to others, or distributed through bulletin
- board systems, etc.
-
- As a recipient of a shareware program, you may use the software for
- a short trial period to determine if it meets your needs. If it
- does, you pay the registration fee. By paying the fee, you are
-
-
- Copyright (c) 1989-91 Bowen Software Page 6
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- granted the right to retain the software for your use. If the
- software is not suitable, then you may discard it.
-
- The shareware system provides significant benefits to the computing
- community (of which YOU are a member):
-
- 1) You get to try out the software BEFORE you buy it so you
- know exactly what you're buying.
-
- 2) Shareware is substantially less expensive than most
- commercial programs. You don't pay for costly marketing
- programs and fancy packaging.
-
- 3) You get access to a MUCH broader base of available
- programs. Thousands of excellent programs have been
- written by expert programmers who would never consider
- marketing commercially. Through the concept of shareware,
- these people make their programs available to the
- community. Usually, all they ask in return is a small fee
- to reward them for the time and effort they've put into
- the program.
-
- The system is based entirely on the honor system, and generally
- works quite well (Most people are honest and wouldn't violate the
- trust placed in them by the author of the software!). Shareware is
- NOT free software - the author counts on your integrity.
-
-
- 1.6 ASP Ombudsman Information
-
- Bowen Software is an author member of the Association of Shareware
- Professionals (ASP). ASP wants to make sure that the shareware
- principle works for you. If you are unable to resolve a
- shareware-related problem with an ASP member by contacting the
- member directly, ASP may be able to help. The ASP Ombudsman can
- help you resolve a dispute or problem with an ASP member, but does
- not provide technical support for members' products. Please write
- to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a
- Compuserve message via Compuserve Mail to ASP Ombudsman 70007,3536.
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 7
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- 1.7 Technical Support
-
- You can contact Bowen Software by leaving messages on Compuserve to
- 76665,736. The latest version of PopDBF can be found on Compuserve
- in the IBMAPP forum Data Library 3. We recommend that anyone who
- accesses Compuserve frequently use another Shareware program called
- TapCIS to automate the online processes. TapCIS can save users both
- time and money. To learn more about TapCIS when on Compuserve, type
- GO TAPCIS when online.
-
- Bowen Software shareware products can be found on many Bulletin
- Board Systems (BBS) across the country. We directly upload our
- products to the Exec-PC bulletin board located in Milwaukee,
- Wisconsin. The Exec-PC phone number is (414) 789-4210. Electronic
- messages can be left on Exec-PC and should be addressed to Don
- Bowen.
-
- To contact Bowen Software via Internet, leave messages to
- 76665.736@COMPUSERVE.COM.
-
- Contacting us using the above methods is preferred. If you do not
- have access to electronic communication you can contact us by phone
- at (309) 699-0950. Messages are usually returned within 24 hours.
-
- The cheapest way to ask questions or make suggestions is by mail.
- Send inquiries or recommendations to:
-
- Bowen Software
- P. O. Box 2134
- East Peoria, IL 61611
-
- Registered and commercial users are provided free technical support
- on the phone for at least six months. No support is guaranteed for
- non-registered users, but we are happy to answer questions about our
- products and consulting services. Bowen Software can be reached at
- (309) 699-0950. Registered users will be asked for their serial
- number.
-
- Also, if you are having problems, be prepared to describe the
- hardware and operating system you are using as well as the
- CONFIG.SYS and AUTOEXEC.BAT files.
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 8
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- 1.8 Trademark Acknowledgements
-
- Association of Shareware Professionals and the ASP Logo are
- trademarks of the Association of Shareware Professionals.
- CLIPPER is a trademark of Nantucket Corporation.
- COMPAQ is a registered trademark of COMPAQ Computers, Inc.
- dBASE and dBASE III are registered trademarks of Ashton Tate, Inc.
- dBASE III Plus and dBASE IV are trademarks of Ashton Tate, Inc.
- dBXL and Quicksilver are trademarks of Wordtech Systems, Inc.
- Desqview and QEMM are trademarks of Quarterdeck Office Systems.
- FoxBASE+ is a registered trademark of Fox Software, Inc.
- FoxPro is a trademark of Fox Software, Inc.
- PC-FILE is a registered trademark of Buttonware, Inc.
- PopDBF is a trademark of Bowen Software.
- Sidekick is a trademark of Borland International, Inc.
-
- Other product names mentioned in this document may be trademarks or
- registered trademarks of their respective companies.
-
-
- 1.9 License Agreement, Disclaimer and Warranty
-
- BY INSTALLING PopDBF ON YOUR SYSTEM YOU INDICATE YOUR AGREEMENT TO
- THE FOLLOWING TERMS AND CONDITIONS. IF YOU DO NOT AGREE TO THEM YOU
- ARE NOT ALLOWED TO USE THIS PROGRAM.
-
- PopDBF, its documentation and supplementary files and programs are
- Copyright (c) 1989-91 Bowen Software. All rights reserved world
- wide.
-
- PopDBF is not now, nor was it ever, public domain or free software.
- PopDBF is currently available in shareware and commercial versions.
-
- 1.9.1 Shareware Version License
-
- The Shareware evaluation (trial use) version is provided AS IS.
- Bowen Software MAKES NO WARRANTY OF ANY KIND, EXPRESSED OR IMPLIED,
- INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY
- AND/OR FITNESS FOR A PARTICULAR PURPOSE.
-
- You are granted a limited license to use PopDBF for evaluation
- purposes for a period not to exceed sixty (60) days. If you
- continue to use PopDBF after the sixty (60) day evaluation period,
- you must make a registration payment of $35US to Bowen Software.
-
-
- Copyright (c) 1989-91 Bowen Software Page 9
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Introduction
-
-
- Failure to make this payment after the evaluation period is
- considered to violate this license.
-
-
- 1.9.2 Registered Version License
-
- If you are a registered user of PopDBF, you may use the registered
- version on one computer at a time and make copies for backup (for
- your own use ONLY) as needed.
-
- You may not distribute the registered version of PopDBF to any other
- person via any form of media.
-
-
- 1.9.3 Warranty
-
- This software is provided "as is" without any warranty of any kind,
- either expressed or implied, including, but not limited to, the
- implied warranties of merchantability and fitness for a particular
- purpose. The entire risk as to the quality and performance of the
- software is with you. Should the software prove defective, the
- user, NOT Bowen Software, assumes the entire cost of all necessary
- servicing, repair or correction.
-
- In no event shall Bowen Software be liable to the user for any
- damages, including lost profits, lost savings or other incidental or
- consequential damages arising out of the use or inability to use
- this software, even if Bowen Software has been advised of the
- possibility of such damages, or for any claim by any other party.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 10
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- 2 Getting Started
-
- 2.1 Installing PopDBF
-
- To load the PopDBF and its associated programs and files on your
- hard disk, you use the installation program called INSTALL.EXE. To
- run the installation program, do the following:
-
- 1. Place the PopDBF diskette in drive A:
-
- 2. Type A:INSTALL and press ENTER.
- (If you are using drive B, substitute B: for A: above)
-
- 3. Make sure that the name of the installation directory is
- correct and press ENTER. The installation directory is
- where the PopDBF files will be copied. If the directory
- you specify does not exist, it will be created.
-
- 4. You will see the names of each of the files as it is being
- copied to the destination directory. When all the files
- have been copied, the message "press any key..." will be
- displayed in the lower left corner of the screen. Press
- any key and you will be returned to DOS and will be in the
- directory you specified as the installation directory.
-
- NOTE: When PopDBF is executed it assumes that POPDBF.HLP, the
- context sensitive help file, is in the same directory as
- POPDBF.EXE. If POPDBF.HLP is not in that directory,
- context sensitive help will not be available. See "Help"
- on page 21.
-
- 2.2 Executing PopDBF
-
- PopDBF can be run in two modes. Normally, when PopDBF is executed
- it installs itself into memory for access from anywhere by pressing
- its hotkey. Alternatively, you can run PopDBF in non-resident
- "pass-thru" mode like any other DOS program.
-
- 2.2.1 Running PopDBF in Memory Resident Mode
-
- To run PopDBF in memory resident mode, just type POPDBF at the DOS
- prompt and press ENTER. It is in this mode that PopDBF can become
- an invaluable tool. Once loaded into memory, pressing the hotkey
- (the default hotkey is Alt-BackSpace) will give you "instant access"
-
-
- Copyright (c) 1989-91 Bowen Software Page 11
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- to your X-Base files! See "Command Line Options" on page 13 for a
- list of configuration options.
-
- PopDBF does not need to be the last memory resident program.
- However, it can NOT be uninstalled from memory if it is not the last
- memory resident program or if another memory resident program has
- recaptured one of PopDBF's interrupts.
-
- When PopDBF is installed in memory it requires only 4K of RAM!
-
- If the /SN command line option is used to prevent swapping to disk
- or EMS, PopDBF will require around 45K of RAM. This may be a
- desirable mode if no EMS is available, the local hard disk is very
- slow and most of the lower 640K of RAM is available for application
- programs.
-
- NOTE: When disk swapping is used a hidden file is created (by
- default POPDBF.SWP) and placed in the root directory of
- the currently logged drive. This file is automatically
- removed if PopDBF is removed from memory. DO NOT REMOVE
- THIS FILE WHILE POPDBF IS IN MEMORY.
-
-
- 2.2.2 Running PopDBF in Non-Resident Mode
-
- The second mode of operation is to run PopDBF in "Pass-Thru" mode.
- In "Pass-Thru" mode, PopDBF works like most other programs. To do
- this type POPDBF /p at the DOS prompt and press ENTER.
-
- In this mode the hotkey is ignored. To exit PopDBF in this mode
- press the ESCAPE key until you return to the DOS prompt.
-
- When using this mode, the Ctrl-P paste key in Edit mode is disabled.
-
- Memory consumption in "Pass-Thru" mode depends on command line
- options, but will default to using 45K of RAM.
-
-
- 2.3 Modifying AUTOEXEC.BAT to Load PopDBF
-
- To have PopDBF load each time you start your computer, add the
- following line to your AUTOEXEC.BAT file:
-
- .
- [path\]POPDBF [options] <load PopDBF into memory>
-
- Copyright (c) 1989-91 Bowen Software Page 12
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- .
-
- If the optional path is not specified, POPDBF.EXE must either be in
- the current directory or in the PATH.
-
- For help on which options to use when loading PopDBF see "Command
- Line Options" on page 13.
-
-
- 2.4 Removing PopDBF from Memory
-
- To remove PopDBF from memory use the /U command line option by
- typing the following at the DOS prompt:
-
- POPDBF /U
-
- PopDBF must be the last memory resident program or you will receive
- an error message indicating that PopDBF was unable to unload. See
- /U under "Command Line Options" below for further information on
- this option.
-
-
- 2.5 How to Invoke PopDBF (Using the "Hotkey")
-
- By default the hotkey to invoke PopDBF is Alt-BackSpace. To invoke
- PopDBF, press and hold the Alt key and at the same time press the
- BackSpace key.
-
- As soon as you press the hotkey, PopDBF will "pop" onto the screen.
- Pressing the hotkey again will take you right back to the
- interrupted program. You can pop out of PopDBF from anywhere in
- PopDBF, except a few places when you are being prompted for
- information. At those times, pressing the hotkey will abort that
- action just as if you had pressed ESCAPE.
-
- When you press the hotkey to leave PopDBF, any open database is
- automatically closed. Pressing the hotkey again will return you to
- the same location in PopDBF with the file being opened automatically
- as if it had never been closed. You can even pop out and back in
- while in the middle of using Edit or Append!
-
- 2.6 Command Line Options
-
- To load or execute PopDBF type the following at the DOS prompt:
-
-
- Copyright (c) 1989-91 Bowen Software Page 13
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- PopDBF [options], where options can be:
-
- /A<A|B|E|S> Default action, where:
-
- A>ppend <B>rowse E>dit S>tructure
-
- The default is to open databases in Browse mode. To
- load PopDBF so that databases are opened in Edit
- mode, use the following command line:
-
- POPDBF /AE
-
- /C<C|M|O> Color scheme, where:
-
- M>ononchrome O>riginal
-
- The original colors option is provided for those
- people who liked the colors used in versions of
- PopDBF before 3.7.
-
- To load or run PopDBF so that monochrome colors are
- displayed, use the following command line:
-
- POPDBF /CM
-
- /D<dir> Initial PopDBF Directory
-
- The format of <dir> is [d:\]path, where d: is the
- optional disk drive identifier.
-
- The initial PopDBF directory is set to the current
- DOS directory the first time PopDBF invoked, if this
- option is not specified.
-
- The PopDBF directory changes only when a move is made
- from within PopDBF. Each time PopDBF is invoked, the
- current DOS directory is saved and the PopDBF
- directory becomes the current directory. When
- leaving PopDBF the DOS directory is restored. See
- also "Move to Current DOS Directory" on page 28.
-
- To load or run PopDBF so that the starting directory
- is C:\DBASE, use the following command line:
-
- POPDBF /DC:\DBASE
-
- Copyright (c) 1989-91 Bowen Software Page 14
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- /E<size> Edit buffer of size bytes (default = 512)
-
- If a file has a record size larger than the edit
- buffer size, you will not be allowed to Edit or
- Append. Should this occur an error message will be
- displayed. To determine the minimum size that you
- will need to specify to allow Editing on the file,
- press Alt-S to view the record size.
-
- To load or run PopDBF so that you can Edit a record
- 1024 bytes long, use the following command line:
-
- POPDBF /E1024
-
- /F<num> Maximum of num fields (default = 64, max = 1024)
-
- The default value should handle most needs, however
- Clipper databases can have up to 1024 fields.
-
- Should you try to Browse or Edit a database with too
- many fields, an error message will be displayed. To
- determine the minimum number of fields you will need
- to specify to allow Browsing or Editing the file,
- press Alt-S to view the number of fields.
-
- To load or run PopDBF so that you can Browse or Edit
- a file with 95 fields, use the following command
- line:
-
- POPDBF /F95
-
- /G<num> Maximum of num files (default = 100, min = 3)
-
- The default value should handle most directories,
- unless the file specification is changed to *.*.
- Files matching the file specification are loaded
- first, then any sub-directories in the current
- directory.
-
- If too many files are found, you will be notified by
- an error message that the /G option should be used to
- correct the problem. Just press any key to respond
- to the error. Only the specified number of files
- will be displayed.
-
-
- Copyright (c) 1989-91 Bowen Software Page 15
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- To load or run PopDBF so that 200 files can be
- displayed in the Pick File window, use the following
- command line:
-
- POPDBF /G200
-
- /H Command line syntax and options
-
- This will list all of PopDBF's command line options.
- You can also specify a single question mark (?).
-
- /I Ignore hotkey, toggles on and off
-
- To use this option, run PopDBF from the DOS prompt
- with this option. This can be used if for some
- reason you want to disable the PopDBF hotkey
- temporarily. To reactivate the hotkey run PopDBF
- using this option again.
-
- /L<dir> Directory where master .FRQ file is located
-
- Normally, the frequent database access list file is
- located in the same directory as the PopDBF
- executable. However, when PopDBF is loaded from a
- Network drive, users will probably want to specify a
- local drive and directory where their personal
- frequent database access list file is located using
- this option.
-
- To load or run PopDBF and specify that the master
- .FRQ file is located in F:\PUBLIC, use the following
- command line:
-
- POPDBF /LF:\PUBLIC
-
- /[!]P[file] Use "Pass-Thru" non-resident mode
-
- This option will NOT load PopDBF into memory, but
- will execute it and allow you to use all of its
- features.
-
- If a file is also specified (no brackets are
- necessary), PopDBF will automatically come up in that
- file in Browse, unless the /A option is used to
- specify a different action.
-
- Copyright (c) 1989-91 Bowen Software Page 16
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- Pass-Thru mode is indicated on the screen by the word
- "PASSTHRU" in the upper left-hand corner. The /P
- option can also be used even if PopDBF is already in
- memory without affecting the resident version.
- Pressing the PopDBF hotkey will cause the resident
- version to pop up over the Pass-Thru version.
-
- Preceding the P with an exclamation point (!) will
- cause PopDBF to exit when ESCAPE is pressed from
- Append, Browse, Edit, or Setup. This is a nice
- feature to use from batch files, so that users only
- have to press ESCAPE once to exit PopDBF.
-
- To run PopDBF in "Pass-Thru" mode and automatically
- open C:\DBASE\ROLODEX in Edit mode, use the following
- command line:
-
- POPDBF /AE /PC:\DBASE\ROLODEX
-
- /R<size> Read buffer of size bytes (default = 4096)
-
- If a file's record size is larger than the read
- buffer size, you will not be allowed to Browse the
- file.
-
- The larger the read buffer the faster scrolling and
- finding will be done when in Browse and Edit.
-
- Specifying a larger read buffer will not affect
- memory consumption unless PopDBF is run using the /SN
- option to prevent swapping.
-
- To load or run PopDBF using a 16K read buffer, use
- the following command line:
-
- POPDBF /R16184
-
- /S<D|E|N> Swap to Disk|EMS|None
-
- D for Disk swap, E for EMS swap, N for No swap.
-
- If this option is not specified, swapping to EMS will
- be attempted first and swapping to Disk will be
- attempted second. If both fail, no swapping will be
- done.
-
- Copyright (c) 1989-91 Bowen Software Page 17
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- If Disk swapping is done, it can be helpful to use
- the /X option to specify that the swap file be
- located on a RAM drive or a Network drive. This can
- greatly decrease swap time.
-
- To load PopDBF so that it does disk swapping to a RAM
- drive E: and a swap file name called POPDBF.SWP in
- the root directory, use the following command line:
-
- POPDBF /SD /XE:\POPDBF.SWP
-
- To load PopDBF so that it does NOT swap to disk or
- EMS and resided entirely in memory, use the following
- command line:
-
- POPDBF /SN
-
- /T<B,C,I,V,W,Z>
- Toggle indicator defaults
-
- Any or all of the toggle indicator letters may be
- specified to override the defaults. The letters and
- the toggle indicator they modify are discussed below.
- The /W option should be specified as /TW. However,
- it will still function to provide backward
- compatibility.
-
- B - Borders for fields ON
-
- Specifying this option forces all finds to be
- successful only if WITHIN field borders.
-
- C - Case sensitive
-
- Specifying this option forces all finds to be
- sensitive to upper and lower case letters.
-
- I - Insert mode
-
- When insert mode is on and you are entering
- information or editing a record, characters to the
- right will move to the right as you enter data.
-
- V - Verify mode in Edit
-
-
- Copyright (c) 1989-91 Bowen Software Page 18
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- When verify mode is on you will be required to press
- ENTER in Edit to move to the next field. When verify
- mode is on a "V" is displayed in the upper right
- border of the Edit window.
-
- W - Write file access
-
- Specifying this option will cause each database to be
- opened with read-write access.
-
- Z - Zoom the Browse window
-
- By default the Browse window shows only 12 records.
- When zoomed it will show 18 records. See also "Zoom
- Browse Window" on page 33.
-
- For more information on toggle indicators, see "Alt
- Toggle Keys" on page 23.
-
- To load or run PopDBF so that read-write mode is on
- and finds are done with case sensitivity, use the
- following command line:
-
- POPDBF /TCW (you can combine options)
-
- /U Uninstall (remove) from memory
-
- This will remove PopDBF from memory, but ONLY if it
- is the last memory resident program.
-
- In some special cases, even when PopDBF is the last
- memory resident program it can't be removed from
- memory. This occurs if another resident program
- recaptures one of the interrupt vectors after PopDBF
- has chained into it. Sidekick is an example of this
- type of program.
-
- /X<file> File name for swapping to Disk
-
- If PopDBF swaps to Disk, it can be very beneficial to
- use this option to direct the swap file to a RAM
- drive or Network drive (if faster than local hard
- disk). This can greatly decrease the swap time. The
- default is POPDBF.SWP in the root directory on the
-
-
- Copyright (c) 1989-91 Bowen Software Page 19
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Getting Started
-
-
- current drive. This file is created as a hidden
- file.
-
- /Y<file> Initial PopDBF File
-
- This is very similar to the Pass-Thru option, but is
- used for memory resident mode. This is the file that
- will be opened when PopDBF is first activated. It is
- an especially nice feature to use for people who
- usually access one file.
-
- To load PopDBF so that the first time it is popped up
- it opens C:\DBASE\ROLODEX in Edit mode with read-
- write mode on, use the following command line:
-
- POPDBF /AE /TW /YC:\DBASE\ROLODEX
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 20
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Help
-
-
- 3 Help
-
- Help is available in PopDBF only if the file POPDBF.HLP is in the
- same directory as POPDBF.EXE, the main program.
-
- While in Help you can press the up and down arrow keys as well as
- PgUp and PgDn to scroll the help text. To get out of Help, press
- ESCAPE.
-
-
- 3.1 Generic Help (Alt-F1)
-
- You can get generic help about the system by pressing Alt-F1 from
- any area of the program.
-
- The generic help explains the Alt Action and Toggle Keys and the
- toggle indicators. See "Alt Menu" on page 22. It also explains
- cursor and lite-bar movement.
-
-
- 3.2 Context Sensitive Help (F1)
-
- Pressing F1 will provide specific help for any area of PopDBF. The
- help provided is basically the same text found in this manual and in
- some cases is even more thorough.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 21
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Alt Menu
-
-
- 4 Alt Menu (Alt)
-
- Pressing the Alt key will show the Alt menu on the status line.
- Releasing the Alt key will restore the previous status line. The Alt
- menu is divided into two parts, "Action Keys" and "Toggle Keys".
- Pressing Alt and one of the highlighted Action Keys will cause the
- appropriate action to occur. Pressing Alt and one of the
- highlighted Toggle Keys will toggle the appropriate indicator in the
- indicator window located in the lower left border of the main
- window.
-
- 4.1 Alt Action Keys
- Alt Action Keys will have no effect when responding to an error, a
- prompt, or inside of Help. They also have no effect while
- positioned on a directory in the Pick File window.
-
- The Alt Action Keys are:
-
- Alt-A Append records in the current database. Ignored if
- file access mode is read-only.
-
- Alt-B Browse records in the current database. If pressed
- while in Edit or Append is the same as pressing
- ESCAPE to abort. See "Abort and Lose Changes" on
- page 40.
-
- Alt-E Edit records in the current database. If the file
- access mode is read-only, Edit acts as a full screen
- record viewer.
-
- Alt-P Pick a different database or directory. If pressed
- while in Edit or Append is the same as pressing
- ESCAPE to abort.
-
- Alt-S Setup View of current database. If pressed while in
- Edit or Append is the same as pressing ESCAPE to
- abort.
-
- There are potentially 12 other Alt Action keys. These keys are used
- to access frequently used databases. For more information on
- Frequent Database Access keys, see FREQUENT DATABASE ACCESS on page
- 28.
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 22
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Alt Menu
-
-
- 4.2 Alt Toggle Keys
- Alt Toggle Keys will function regardless of where you are in the
- program.
-
- The Alt Toggle Keys are:
-
- Alt-C Toggles the case sensitivity indicator between "IC",
- ignore case, and "CS", case sensitive. This
- indicator affects how the Find function does its
- search. See "Find Text" on page 34.
-
- Alt-D Toggles the field border indicator between "NB", no
- borders, and "BO", borders on. This indicator also
- affects how the Find function behaves.
-
- Alt-I Toggles the insert/overstrike indicator between "IN",
- insert mode, and "OV", overstrike mode. This
- indicator affects how text is placed into fields in
- Edit. It can also be toggled by pressing Insert.
-
- Alt-M Toggles the file access mode indicator between "RO",
- read-only mode, and "RW", read-write mode. When the
- file access mode is read-only, you will not be
- allowed to Edit or Append.
-
- On a NETWORK read-write mode will open files for
- EXCLUSIVE access. Read-only will open files so that
- multiple users can have access. Record level locking
- is not currently implemented.
-
- If opening a file in read-write mode fails, an
- attempt to open the file in read-only mode will
- automatically be made. If successful, when the file
- is closed, the mode will automatically return to
- read-write.
-
- Alt-F5 Toggle viewing underlying application screen. This
- avoids having to swap out and back.
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 23
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Alt Menu
-
-
- 4.3 Toggle Indicator Summary
-
- The default values for the toggle indicators are given below.
-
- --| RW IC BO OV |--
- | | | |
- | | | -- IN/OV: edit mode is insert/overstrike
- | | ----- BO/NB: field borders are on/off
- | -------- IC/CS: case sensitivity is off/on
- ----------- RO/RW: file access mode is read-only/read/write
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 24
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Alt Menu
-
-
- 5 Cursor and Lite-Bar Movement
-
- UpArrow/DownArrow Move up or down one entry or line
- Ctrl-UpArrow/Home First entry or line in current window
- Ctrl-DownArrow/End Last entry or line in current window
- PgUp Move up one "screen"
- PgDn Move down one "screen"
- Ctrl-PgUp Move to first entry or record
- Ctrl-PgDn Move to last entry or record
-
-
- 5.1 The "Wordstar" Diamond
-
- Many of the basic Wordstar control key combinations have been
- implemented to maintain some compatibility with other programs.
- These keystrokes are found in many of the editors users have become
- familiar with.
-
- Ctrl-Q Abort
- Ctrl-E Move up one entry or line (like UpArrow)
- Ctrl-R Move up one page or screen (like PgUp)
- Ctrl-A Move one word to the left (like Ctrl-LeftArrow)
- Ctrl-S Move one character or field to the left (like LeftArrow)
- Ctrl-D Move one character or field to the right (like RightArrow)
- Ctrl-F Move one word to the right (like Ctrl-RightArrow)
- Ctrl-X Move down one entry or line (like DownArrow)
- Ctrl-C Move down one page or screen (like PgDn)
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 25
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Pick File
-
-
- 6 Pick File (Alt-P)
-
- Pressing any letter will move the lite-bar to the first file or
- directory that begins with that letter. Successive presses of the
- same letter will move to the next file or directory that begins with
- that letter. If no file or directory begins with the letter
- pressed, no movement will occur.
-
-
- 6.1 Select Directory/File/Index (Enter)
-
- Pressing ENTER will cause one of the following to occur:
-
- * If the file is a directory, you will move to that
- directory. Once in that directory the Pick File window is
- refreshed with the names of files that match the file
- specification.
-
- * If the file is a database, the action taken corresponds to
- the currently specified Action letter. This can be
- changed by pressing F5 (see "Change Default Action" on
- page 27). It is the same as pressing Alt-<action letter>.
-
- * If the file is an index (.NDX, .IDX, .NTX only), you will
- view the index expression used to create it. You can
- press Ctrl-I to change the file specification to show only
- index files. Pressing Ctrl-B will change the file
- specification back to show only database files.
-
-
- 6.2 Move to Parent Directory (BackSpace)
-
- Pressing BackSpace will take you to the parent of the current
- directory, unless you are currently in the root directory. This
- feature is especially useful on a network, where no parent directory
- will be shown in the Pick File window, but the function still works.
- The lite bar will be positioned on the name of the directory you
- came from.
-
-
- 6.3 Change Directory and/or Drive (F2)
-
- Pressing F2 will allow you to change the current PopDBF directory
- and/or drive. The name supplied can be a drive letter followed by a
-
-
- Copyright (c) 1989-91 Bowen Software Page 26
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Pick File
-
-
- colon (C:), a directory path (\DBASE\PAYROLL), or both
- (C:\DBASE\PAYROLL).
-
- If the new directory is invalid, an error message will be displayed.
- If it is valid the file selection window will be filled with files
- matching the current file specification.
-
-
- 6.4 Enter A Specific File (F3)
-
- Pressing F3 will allow you to enter a specific file name. If the
- file is not found or is not a valid database or index, an error
- message will be displayed. If no extension is entered, the
- extension in the file specification will be used. This will cause
- an error if that extension contains a wildcard (*/?) and you will
- need to enter the file extension as well.
-
-
- 6.5 Change File Specification (F4)
-
- Pressing F4 will allow you to modify the file specification located
- in the upper right corner of the main window. The file
- specification is used to determine which files in the current PopDBF
- directory you are allowed to pick from. Entering a file
- specification of *.* will allow you to pick from all files, while
- *.DBF will allow only files with an extension of .DBF.
-
- The names of any sub-directories in the current PopDBF directory are
- included for possible selection regardless of the file
- specification.
-
-
- 6.6 Change Default Action (F5)
-
- The current default action is displayed in the upper left portion of
- the file selection window. The default action determines what
- happens when you press Enter and the selection bar is on a valid
- database file. Each press of F5 will change the action as follows:
-
- Append -> Browse -> Edit -> Setup -> Append, etc.
-
- The result is the same as holding the Alt key and pressing the first
- letter of the appropriate action. You can override the default
- action by holding the Alt key and pressing a different action key
- while the lite bar is positioned on the desired database.
-
- Copyright (c) 1989-91 Bowen Software Page 27
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Pick File
-
-
-
- 6.7 Delete File (F6)
-
- Pressing F6 will allow you to delete a file. You will be asked to
- verify that you really want to delete the file. If you answer with
- a Y for yes, the file will be deleted. Pressing ESCAPE or N for no,
- will cancel the delete.
-
- When the lite bar is on a directory, this function is ignored.
-
-
- 6.8 Move to Current DOS Drive & Directory (F10)
-
- Pressing F10 will move you to the current DOS directory. The
- current DOS directory is the directory you were in before the PopDBF
- hotkey was pressed or when you loaded PopDBF. If that directory is
- on a drive other than the current drive, that drive becomes the
- current drive as well.
-
- This is a handy function to use when you want to move from wherever
- you were using PopDBF last to the directory where you are currently.
-
-
- 6.9 Frequent Database Access (Alt-1 thru Alt-=)
-
- To use this feature you must have already created an ASCII file
- named POPDBF.FRQ containing the names of up to 12 frequently used
- databases. Multiple POPDBF.FRQ files can exist. PopDBF will look
- first in the current directory and then in the directory from which
- it was executed, unless the /L option was specified on the command
- line.
-
- Each database name can include a drive identifier and path. It MUST
- include file name and extension. Optionally, each file can be
- preceded by an action letter and a space. See "Change Default
- Action" on page 27 for more information on action letters.
-
- Pressing Alt-1 will access the database whose name is on the first
- line of this file, Alt-2 will access the second, and so on. If more
- than 12 lines are included POPDBF.FRQ they are ignored.
-
- Examples of lines in POPDBF.FRQ:
-
- C:\ME\DBF\ROLODEX.DBF (use default action)
- E C:\PERSONAL\MILEAGE.DBF (open database in Edit mode)
-
- Copyright (c) 1989-91 Bowen Software Page 28
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Pick File
-
-
- A MILEAGE.DBF (open database in Append mode)
-
- Using this feature while in the middle of Edit or Append, will save
- any current changes.
-
- The mode and current record number is maintained on each frequently
- accessed database. If you press Alt-1, then go off and use other
- files and press Alt-1 again you will be returned to the same mode
- and positioned at the same record. This is very handy for toggling
- between any of the 12 possible frequent databases.
-
-
- 6.10 Show Names of Frequently Accessed Databases (Ctrl-N)
-
- Pressing Ctrl-N will pop up a window to show the names of the files
- in the current frequent database access file. Each name will be
- preceded by an action letter, if it was specified. Currently, you
- can not change these names from within PopDBF.
-
-
- 6.11 Program Information
-
- Pressing Ctrl-H will pop up a window to show you the version of the
- context sensitive help file, along with other information on PopDBF
- and Bowen Software.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 29
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Setup View
-
-
- 7 Setup View (Alt-S)
-
- Setup View can be used to create a customized view of the currently
- opened database. You can select only the fields you want to view in
- Browse or Edit. You can even order the fields differently than they
- are physically laid out in the database. This ordering (as
- described below) is not permanent.
-
- Pressing any letter will move the lite-bar to the first field that
- begins with that letter. Successive presses of the same letter will
- move to the next field that begins with that letter. If no field
- begins with the letter pressed, no movement will occur.
-
-
- 7.1 Return To Data (Enter)
-
- Pressing ENTER will return you to either Browse or Edit/Append,
- depending on which you were in last. This makes changing the Setup
- View (by pressing Alt-S) and returning to data (Browse or Edit) a
- little easier.
-
-
- 7.2 Number/Un-Number Fields (Space)
-
- Pressing the SPACE bar will number/un-number the field at the
- selection bar. If any fields are numbered, only those fields will
- be shown when you Browse or Edit records. The number beside the
- field determines the order in which it will be displayed. Two
- fields with the same number will remain in the same relative
- position to each other.
-
- Pressing SPACE will automatically move the selection bar down to the
- next field, unless it is on the last field.
-
-
- 7.3 Clear Field Numbers (F2)
-
- Pressing F2 will clear all field numbers, but leave the file
- structure in the present order. This means that you can assign
- field numbers, press F4 to order the fields, and then remove all
- field numbers by pressing F2. This will allow you to view all
- fields but in an order different from the original. Field numbers
- are also cleared when a new file is selected from the Pick File
- window.
-
-
- Copyright (c) 1989-91 Bowen Software Page 30
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Setup View
-
-
- 7.4 Assign a Specific Field Number (F3)
-
- Pressing F3 will allow you to assign a specific number (0-1024) to a
- field to affect its order. Assigning a zero will un-number the
- field.
-
-
- 7.5 Order Fields Using Field Numbers (F4)
-
- Pressing F4 will reorder the fields in the structure based on their
- field numbers. THIS NEW ORDER IS NOT PERMANENT. The actual
- structure of the file on disk is NOT affected. To restore the
- original field order either return to the Pick File window and re-
- select the file or clear all field numbers by pressing F2 and press
- F4 again.
-
-
- 7.6 Tag/Un-Tag Field for Exclusive Find (F6)
-
- Pressing F6 will tag/un-tag the field at the selection bar for
- exclusive find. When any fields are tagged for exclusive find, only
- those fields are used when doing a Find or Find Next from Browse or
- Edit. Also, if the field border indicator is on (see "Toggle
- Indicators Summary" on page 24), the text being searched for MUST be
- found entirely within ONE field. For more information see "Find
- Text" on page 34.
-
- Pressing F6 will automatically move the selection bar down to the
- next field, unless it is on the last field.
-
-
- 7.7 Clear Exclusive Find Tags (F7)
-
- Pressing F7 will turn off the exclusive find indicator for all
- fields.
-
- This will allow Find and Find Next to locate text anywhere in the
- record, unless field borders are on, in which case it must be
- entirely within ONE field. Exclusive find tags are also cleared
- when a new file is selected from the Pick File window.
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 31
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Setup View
-
-
- 7.8 Copy File Structure (F8)
-
- Pressing F8 will allow you to copy the current database file
- structure to another file. You will be prompted for the new
- database file name. Pressing ESCAPE will abort this function. If
- any fields are marked, only those fields, and in their specified
- order, will be copied.
-
- If the specified file already exists, you will be asked if you want
- to overwrite it. NO CHECK IS DONE TO INSURE THAT YOU DO NOT SPECIFY
- THE SAME FILE YOU ARE CURRENTLY VIEWING.
-
-
- 7.9 Print the File Structure (F9)
-
- Pressing F9 will print the file structure. If any fields are
- numbered only those fields will be printed. The file statistics are
- printed first followed by the field structure.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 32
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Browse Records
-
-
- 8 Browse Records (Alt-B)
-
-
- 8.1 Current Record and Delete Status
-
- The current record number and delete status are displayed in the
- bottom border of the Browse window. See below for directions on how
- to delete a record.
-
-
- 8.2 Toggle Vertical Separator Bars On/Off (Shift-|)
-
- Pressing Shift-| (pipe symbol) will toggle the vertical separator
- bars on and off. The default is off. Viewing can be a little
- easier with them on, but printing is best done with the separators
- off.
-
-
- 8.3 Pan the Browse Window (LeftArrow/RightArrow)
-
- The LeftArrow and RightArrow will allow you to pan to the left and
- right, respectively.
-
-
- 8.4 View Large Fields (Tab/Shift-Tab)
-
- Tab and Shift-Tab change the offset of fields that are wider than
- the Browse window. The offset is incremented or decremented by 10
- characters. The current offset is displayed in the upper right-hand
- corner of the Browse window.
-
-
- 8.5 Zoom the Browse Window (F2)
-
- Pressing F2 will either expand or contract the Browse window. When
- expanded the window shows 18 records and when contracted shows only
- 12, but has the advantage of allowing you to see the file statistics
- as well.
-
-
- 8.6 Goto a Specific Record (F3)
-
- Pressing F3 will prompt you for a new record position. If the
- record number specified is greater than the number of records in the
-
-
- Copyright (c) 1989-91 Bowen Software Page 33
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Browse Records
-
-
- file, an error will occur and the lite-bar will stay on the same
- record.
-
-
- 8.7 Zap Database (F4)
-
- Pressing F4 will Zap the current database. When a database is
- zapped, all records are deleted AND physically removed. Because
- this is potentially a dangerous function, you will be prompted to
- make sure you really want to zap the database. Pressing ESCAPE or
- entering N will abort. If the database is currently opened in read-
- only (RO) mode, this function will cause an audible beep.
-
-
- 8.8 Pack Database (F5)
-
- Pressing F5 will Pack the current database. When a file is packed,
- all logically deleted records are physically removed. Because this
- is potentially a dangerous function, you will be prompted to make
- sure you really want to pack the database. Pressing ESCAPE or
- entering N will abort. If the database is currently opened in read-
- only (RO) mode, this function will cause an audible beep.
-
- 8.9 Find Text (F7)
-
- Pressing F7 will prompt you for the text you want to locate.
- Type in the text to find and press ENTER to begin the find.
-
- Memo fields are not currently searched.
-
- Date fields need to be searched as follows. If the date you are
- looking for is 11/03/89 you would enter: "891103" or "19891103"
- (don't enter the quotes).
-
- When the case sensitivity indictor is off (IC) finding "don" will
- locate records containing "Don", "DON", and other combinations. To
- find only occurrences of "don", you must first turn on the case
- sensitivity indicator (CS) by pressing Alt-C.
-
- There may be times that you want to find text only if it occurs in a
- specific field or fields, not just anywhere in the record. To do
- this press Alt-S for the Setup View window. Now tag the fields you
- want searched exclusively by pressing F6. When you have tagged the
- fields to be searched, press ENTER to return to the Browse window.
- Now Find will search only the fields you tagged.
-
- Copyright (c) 1989-91 Bowen Software Page 34
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Browse Records
-
-
- By default, Find will locate text even if it crosses field
- boundaries. To prevent this you can turn on the field border
- indicator by pressing Alt-D. When field borders are on (BO), text
- must be found entirely within ONE field. Field borders are on by
- default.
-
- Find can also be used to locate deleted records. Do a find for "*"
- and make sure that field borders are off (NB) and no fields have
- been tagged for exclusive find. This will only work if an asterisk
- is not actually found in one of the database fields.
-
- Find always begins with the first record in the file. See "Find
- Next Occurrence of Text" below to see how to start Find at the
- current record.
-
- If Find fails an audible beep will sound.
-
-
- 8.10 Find Next Occurrence of Text (F8)
-
- Pressing F8 will do a Find Next. Find Next always begins with the
- next record in the file.
-
- To start a Find at the current record you can use Find Next. Press
- F7 and enter the text to find and then press ESCAPE. This will
- cause the find text window to disappear. Now press F8 and the
- search will begin at the next record.
-
- If Find Next fails an audible beep will sound.
-
-
- 8.11 Print Records (F9)
-
- Pressing F9 prompts for print parameters and then prints the data.
- The parameters you will be asked for are the starting record, ending
- record, if only records matching the find text should be used, and
- the width of the print line. Data is printed exactly as it is seen
- in the Browse window, but more text may be printed if a longer print
- width is specified (this is how you print the additional data to the
- right of the Browse window).
-
- Print can be used in conjunction with the find text string to print
- only records that contain certain text. Find behaves here as
- described above under "Find Text".
-
-
- Copyright (c) 1989-91 Bowen Software Page 35
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Browse Records
-
-
- The maximum print width is 250 characters.
-
-
- 8.12 Turn Century On/Off (Ctrl-K)
-
- Pressing Ctrl-K will toggle the century on or off. When on, the
- year of the date displays using four positions as in MM/DD/YYYY
- (unless the date format was changed using the configuration program)
- to show the century.
-
-
- 8.13 Mark Record as Deleted (Ctrl-U)
-
- Pressing Ctrl-U will toggle the delete status of the current record.
- The delete status of the current record is displayed in the bottom
- border of the Browse (and Edit) window. See "Find Text" on page 34
- for a tip on how to find deleted records.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 36
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Edit/Append Records
-
-
- 9 Edit/Append Records (Alt-E/Alt-A)
-
-
- 9.1 Copy a Record (F2)
-
- Pressing F2 will prompt you for the number of the record you want to
- copy into the current record. To append a duplicate of a current
- record you must first go into Append by pressing Alt-A. Then press
- F2 and specify the number of the record to copy. To complete the
- operation, press PgDn.
-
- Pressing Ctrl-F2 will also copy a record, but will use the last
- record you specified to be copied instead of prompting you.
-
-
- 9.2 Goto a Specific Record (F3)
-
- Pressing F3 works the same as it does in Browse. See "Goto a
- Specific Record" on page 33.
-
-
- 9.3 Cut Field into Keyboard Paste Buffer (F4)
-
- Pressing F4 will "cut" the current field into the keyboard paste
- buffer for later pasting inside PopDBF (using Ctrl-P) or outside
- PopDBF (using Ctrl-Alt-P). If data has been cut it will be
- indicated by a "P" in the upper right border of the Edit window.
-
- Trailing blanks are not cut. Each cut field is terminated by a user
- selected key. The termination key is placed into the paste buffer
- after the cut field, unless it is ESCAPE. If a comma (,) is
- pressed, an additional space is placed in the paste buffer after it.
- This is for use with City, State cuts, as well as Lastname,
- Firstname cuts.
-
- If there is not enough room to cut the current field, a beep will
- sound indicating that the field was NOT placed into the buffer.
-
- The entire contents of the keyboard paste buffer can be pasted
- inside PopDBF using Ctrl-P or into an underlying application using
- the paste hotkey Ctrl-Alt-P (the default). Data can be pasted
- multiple times.
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 37
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Edit/Append Records
-
-
- The keyboard paste buffer is cleared when a cut is made and the
- previous paste buffer had been pasted at least once. It can also be
- pasted by pressing Shift-F4.
-
-
- 9.4 Clear Keyboard Paste Buffer (Shift-F4)
-
- Pressing Shift-F4 will clear the keyboard paste buffer.
-
- If data has been cut into the keyboard paste buffer, it is indicated
- by a "P" in the upper right border of the Edit window. Pressing
- Shift-F4 will turn this indicator off.
-
-
- 9.5 Find Text (F7)
-
- Pressing F7 works the same as it does in Browse. See "Find Text" on
- page 34.
-
-
- 9.6 Find Next Occurrence of Text (F8)
-
- Pressing F8 works the same as it does in Browse. See "Find Next
- Occurrence of Text" on page 35.
-
-
- 9.7 Print Records (F9)
-
- Pressing F9 will prompt you for the print parameters and then print
- the data. Data is printed exactly as it appears in the Edit/Append
- window. Blank fields product blank lines.
-
- The extra lines parameter can be used to print labels even if the
- data you are using doesn't fill up all the lines on the label. It
- defaults to one to space between records (or labels).
-
- Records requiring multiple pages of fields currently have to be
- printed separately.
-
- Print can be used in conjunction with the find text string to print
- only records that contain certain text. Find behaves here as
- described above.
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 38
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Edit/Append Records
-
-
- 9.8 Field Information (F10)
-
-
- Pressing F10 will pop-up a window containing information about the
- field in which the cursor is currently positioned. This can be
- helpful if you forget the field type or want to know exactly how
- long it is.
-
-
- 9.9 Restore Field Data (Ctrl-J)
-
- Pressing Ctrl-J will restore the field's original data. Once you
- have moved to another record any changes that were made become
- permanent and can NOT be restored.
-
-
- 9.10 Turn Century On/Off (Ctrl-K)
-
- Pressing Ctrl-K works the same as it does in Browse. See "Turn
- Century On/Off" on page 36.
-
-
- 9.11 System Date (Ctrl-M)
-
- Pressing Ctrl-M while in a date field will place the system date in
- the field. It will only work in a character field if enough room
- remains from the cursor to the end of the field. It will also
- overwrite any existing data in the field at those positions.
-
-
- 9.12 Move to Last Field Position (Ctrl-N)
-
- Pressing Ctrl-N will move the cursor to the last possible position
- in a field.
-
-
- 9.13 Restore Entire Record (Ctrl-O)
-
- Pressing Ctrl-O will restore the entire record's original data. See
- "Restore Field Data" above for when changes in the current record
- become permanent.
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 39
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Edit/Append Records
-
-
- 9.14 Paste Data (Ctrl-P)
-
- Pressing Ctrl-P will paste any data currently in the Paste buffer.
- If there is data to paste, a "P" will be displayed in the upper
- right border of the Edit window.
-
- This feature can be used to copy information from one part of a
- record to another or from one record to another. You can even copy
- data from a record in one database to a record in another database.
-
-
- 9.15 Abort and Lose Changes (Ctrl-Q/ESCAPE)
-
- Pressing Ctrl-Q or ESCAPE will quit Edit and abort any changes made
- to the current record will be lost. If any changes have been made
- you will be asked if you want to lose the changes. Pressing ESCAPE
- will abort and leave you in Edit. Pressing N will save the changes
- and then exit, while pressing Y will exit and the changes will be
- lost.
-
-
- 9.16 Mark Record as Deleted (Ctrl-U)
-
- Pressing Ctrl-U will toggle the delete status of the current record.
- The delete status of the current record is displayed in the bottom
- border of the Edit (and Browse) window. See "Find Text" on page 34
- for a tip on how to find deleted records.
-
-
- 9.17 Toggle Verify Mode On/Off (Ctrl-V)
-
- Pressing Ctrl-V will toggle verify mode. When verify mode is on you
- will be forced to press ENTER to move on to the next field. Verify
- mode is indicated by a "V" in the upper right border of the Edit
- window.
-
- 9.18 Quit and Save Changes (Ctrl-W/Ctrl-End)
-
- Pressing Ctrl-W or Ctrl-End will quit Edit and save any changes made
- to the current record.
-
-
- 9.19 Blank Current Field (Ctrl-Y)
-
- Pressing Ctrl-Y will fill the current field with spaces.
-
- Copyright (c) 1989-91 Bowen Software Page 40
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Edit/Append Records
-
-
-
- 9.20 Blank to End of Field (Ctrl-Delete)
-
- Pressing Ctrl-Delete will delete from the current cursor position in
- the current field to the end of the field.
-
-
- 9.21 Move to End of Data (End)
-
- Pressing the End key will move the cursor to the first blank
- position after any data entered in the current field. If the entire
- field is full, the cursor will move to the last position.
-
-
- 9.22 Move to First Position (Home)
-
- Pressing the Home key will move the cursor to the first position of
- the current field.
-
-
- 9.23 Move Word (Ctrl-LeftArrow/Ctrl-RightArrow)
-
- Pressing Ctrl-LeftArrow or Ctrl-RightArrow will move one word to the
- left or right, respectively. You can also use the Wordstar commands
- Ctrl-A and Ctrl-F to do the same functions.
-
-
- 9.24 Move to First/Last Field (Ctrl-UpArrow/Ctrl-DownArrow)
-
- Pressing Ctrl-UpArrow and Ctrl-DownArrow will move to the first and
- last field respectively, on the current screen.
-
-
- 9.25 Previous Record/Next Record, Same Page (Alt-PgUp/Alt-PgDn)
-
- Pressing Alt-PgUp or Alt-PgDn will move to the previous or next
- record, but stay on the same page. This is very helpful when a
- database has more fields than will fit on one page.
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 41
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Common Questions
-
- 10 Common Questions and Answers
-
- 10.1 How can I change the PopDBF hotkey?
-
- You can change both the main PopDBF hotkey (defaults to Alt-
- Backspace) and the Paste hotkey (defaults to Ctrl-Alt-P) by
- using the PopCFG configuration program.
-
- 10.2 Why doesn't PopDBF pop up in the right directory?
-
- By default PopDBF pops up in the first directory in which the
- hotkey is pressed. To load PopDBF so that it pops up in a
- specific directory, regardless of where you are when you first
- press the hotkey, use the /D<dir> command line option (POPDBF
- /Dc:\dbase).
-
- 10.3 Why are files always opened in Browse mode?
-
- PopDBF uses the default action, displayed in the upper left
- corner of the Pick File window, whenever a database file is
- selected. To change the default action you can press F5 from
- the Pick File window or use the /A<action> command line option
- (POPDBF /Ae).
-
- 10.4 Why doesn't PopDBF display on my Monochrome monitor?
-
- If you have problems getting PopDBF to display on your monitor,
- use the /Cm option to force PopDBF to use monochrome colors.
- You could also use the configuration program to force the
- current colors to be monochrome.
-
- 10.5 How can I change the PopDBF colors?
-
- To change the PopDBF colors you use the configuration program
- PopCFG.
-
- 10.6 How can I use my extended memory?
-
- Load the device driver RAMDRIVE.SYS or VDISK.SYS, following
- directions in your DOS manual. Then use the /X command line
- option and specify the name of the swap file on the RAM drive.
- This will cause PopDBF to swap in and out exceptionally fast.
-
- 10.7 How can I limit displayed fields in Edit or Browse?
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 42
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Common Questions
-
- After selecting a database file, press Alt-S to go to Setup
- View. To mark the fields you want to use press the SPACE bar.
- Press F4 to see the order the fields will be displayed in and
- use F3 to change the order to suit your needs.
-
- 10.8 Why does PopDBF hang when I pop it up on a network?
-
- When loading PopDBF in memory resident mode, it must be loaded
- after any network TSR programs (i.e. IPX, NET3, RPRINTER).
-
- PopDBF can be loaded first if it resides entirely in memory.
- This can be done using the /SN switch.
-
- When loading PopDBF in swap mode (to disk or EMS) it is
- important to load it AFTER programs which must be able to
- operate at all times.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 43
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Error Messages
-
- 11 Error Messages
-
- 11.1 Too many files, Re-install using new /G parm.
-
- The default number of files that will fit into the Pick File
- window is 100. This can be changed using the /G command line
- option. Another way to avoid this error message is to change
- the default file specification to something other than *.DBF
- (which is the default).
-
- 11.2 Too many fields, Re-install using new /F parm.
-
- The default maximum number of fields a file can have is 64. To
- change this use the /F command line option. Until this is
- fixed, you will not be able to load any databases that have
- more fields than were specified (64 if none specified).
-
- 11.3 EDIT buffer too small, Re-install using new /E option.
-
- If the record size of a database is larger than the Edit buffer
- size you will not be allowed to Edit the database. To correct
- this problem, press Alt-S to see the record size and reinstall
- PopDBF using the /E command line option.
-
- 11.4 READ buffer too small, Re-install using new /R option.
-
- If the read buffer size is smaller than the record size of a
- database, you will not be allowed to Browse or Edit the file.
- To correct this problem, press Alt-S to see the record size and
- reinstall PopDBF using the /R command line option. A multiple
- of at LEAST 12 times the size of the biggest record is
- recommended.
-
- 11.5 Not a dBASE compatible file.
-
- If this message is displayed, the first byte of the file is not
- one of the following:
-
- 03h - dBASE3, dBASE4, Foxbase+, FoxPro
- 43h - dBASE4
- 63h - dBASE4
- 83h - dBASE3, Foxbase+ (with memos)
- 8bh - dBASE4 (with memos)
- f5h - FoxPro (with memos)
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 44
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Error Messages
-
- 11.6 Sharing Violation.
-
- If this error message is displayed, it probably means that
- someone else is using the database on the network.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 45
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Configuring PopDBF
-
- 12 Configuring PopDBF
-
- The program PopCFG is provided to allow customized configuration of
- the PopDBF program. You can use PopCFG to change the colors,
- date/number formats, hotkeys and paste options.
-
- To execute the PopDBF configuration program, type the following
- command line at the DOS prompt:
-
- POPCFG
-
- To force monochrome attributes use the command line option /M by
- typing the following command line at the DOS prompt:
-
- POPCFG /M
-
- 12.1 The Configuration Main Menu
-
- ------| Configuration Options |------
- | Colors |
- | Date/Numbers Formats |
- | main Hotkey |
- | Paste Options |
- | Quit - Do NOT Save Changes |
- | eXit - Save Changes |
- -------------------------------------
-
- To execute any menu option, type the first capital letter in that
- option or move the selection bar using the arrow keys and press
- ENTER.
-
- If you press ESCAPE or select the Quit option from the menu and
- changes have been made, you will see the prompt "Abort and lose
- changes [N]?". To quit and lose changes you must then press the
- letter "Y". Pressing ENTER or the letter "N" will return you to the
- main menu.
-
- Changes made using the configuration program are written directly
- into the POPDBF.EXE file.
-
-
- 12.2 Configuring Colors
-
- To change colors use the up and down arrow keys to change the
- category. Use the left and right arrows to change the foreground
- color. Use Ctrl-left and Ctrl-right (press and hold the Ctrl key
-
- Copyright (c) 1989-91 Bowen Software Page 46
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Configuring PopDBF
-
- and then press the left or right arrow key) to change the background
- color.
- To restore the default color for the current category, press the
- letter "D". The default color is the "factory default", meaning it
- is the way PopDBF was when you first received it.
-
- To restore the color for the current category to what it is
- currently in the POPDBF.EXE file, press the letter "O".
-
- To restore all "factory default" colors, press the letter "R".
-
- Press ESCAPE when you are done making color changes to return to the
- main menu.
-
-
- 12.3 Configuring Date/Number Formats
-
- ---------- Date/Number Formats ----------
- | Date Format: U.S. (MM/DD/YY) |
- | date Separator: / |
- | decimal Point: . |
- | Return to Main Menu |
- -----------------------------------------
- press ENTER to toggle an option
-
- The date format rotates through one of the following:
- U.S. (MM/DD/YY)
- ANSI (YY/MM/DD)
- European (DD/MM/YY)
-
- The date separator toggles between a slash (/), dash (-) and period
- (.). When the separator is changed the format correctly reflects
- what the date will look like in PopDBF.
-
- The decimal point toggles between a period (.) and comma (,).
-
- Press "R" or ESCAPE to return to the main menu.
-
-
- 12.4 Configuring Main Hotkey
-
- The main PopDBF hotkey defaults to Alt-Backspace. It can be changed
- to almost any key combination. At least one of the shift keys, Alt
- or Ctrl must be included. It can include Alt, Ctrl and both shift
- keys, but must include at least one of those keys.
-
-
- Copyright (c) 1989-91 Bowen Software Page 47
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Configuring PopDBF
-
- The left and right shift keys are treated differently. Left and
- right Alt and Ctrl keys are treated as being the same key.
-
- After selecting this option you will see:
-
- -------------------------------------------------------------------
- | Main Hotkey Selection: <Alt>Backspace |
- | |
- | Enter new hotkey selection (press ESCAPE to cancel): |
- -------------------------------------------------------------------
-
- Of course the main hotkey selection will display the current main
- hotkey, which may be different if you have changed it.
-
- To cancel changing the hotkey, press ESCAPE at this point.
-
- After you have pressed the new main hotkey, you will be asked to
- confirm your selection. Press "Y" if the hotkey selection is
- correct. Press "N" or ESCAPE if you want to change your selection.
-
- NOTE: Though it is possible to have <LShift>A or other similar
- keys as the PopDBF hotkey, it is recommended that this be
- avoided.
-
-
- 12.5 Configuring Paste Options
-
- ---------| Paste Options |---------
- | Paste Rate |
- | Paste Frequency |
- | Paste Hotkey |
- | Return to Main Menu |
- -----------------------------------
-
- Changing the paste rate, affects the number of keys that are pasted
- per timer tick. This is a number between 1 and 15 and defaults to
- 15, the maximum paste rate.
-
- Changing the paste frequency determines how many timer ticks to wait
- between each group of pasted keys. There are 18.2 timer ticks per
- second. The default is 0, which means keys are pasted every timer
- tick. This can be any value between 0 and 255 (approximately 14
- seconds).
-
- Changing the paste hotkey is the same as changing the main hotkey.
- See "Configuring Main Hotkey" above.
-
- Copyright (c) 1989-91 Bowen Software Page 48
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Index
-
- A C
-
- Action Keys 22 Change
- Alt-A (Append) 22 Default Action 27
- Alt-B (Browse) 22 Directory 26
- Alt-E (Edit) 22 Disk Drive 26
- Alt-F5 (Screen) 23 File Specification
- Alt-P (Pick) 22 27
- Alt-S (Setup) 22 Clipper 1, 9, 15
- Alt Menu 22 Colors
- Alt-A 22, 37 configuration 46
- Alt-B 22, 33 Command Line Options 13
- Alt-BackSpace 1, 11, 13, /A 14
- 42, 47 /C 14
- Alt-E 22, 37 /D 14
- Alt-F1 21 /E 15
- Alt-P 22, 26, 37, 42 /F 15
- Alt-S 15, 22, 30, 34, 43, /G 15
- 44 /H 16
- Append 1, 3, 13, 15, 17, /I 16
- 22, 23, 27, 29, /L 16
- 30, 37, 38 /P 16
- Append Records 37 /R 17
- Applications 2 /S 17
- for Anybody 2 /T 18
- for Consultants 2 /U 19
- for Programmers 2 /X 19
- for Secretaries 2 /Y 20
- ASP 7, 9 Compuserve 5-8
- ASP Ombudsman 7 CONFIG.SYS 8
- AUTOEXEC.BAT 8, 12 Configuration 12, 36, 42,
- 46
- B Configuring PopDBF 46
- Copy
- Blank File Structure 32
- Current Field 40 Record 37
- to End of Field 41 Cursor and Lite-Bar
- Browse 1, 3, 14-17, 19, Movement 25
- 22, 27, 30, 31, Cut 1, 37, 38
- 33, 34-40, 42,
- 44 D
- Browse Records 33
- Browse Window Date fields
- Panning 33 searching 34
- Zooming 33 Date format
- configuration 47
-
- Copyright (c) 1989-91 Bowen Software Page 49
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Index
-
- Dates context sensitive
- Turn Century On/Off 11, 21
- 36 Generic Help 21
- dBASE 1, 4, 9, 14, 17, Hotkey 1, 11-13, 16, 17,
- 20, 27, 42, 44 28, 37, 42, 46,
- dBASE III 1, 9 47, 48
- dBXL 1, 9 configuration 47
- Delete default hotkey 1
- current record 36 Invoking PopDBF 13
- File 28
- Disclaimer 9 I
-
- E Index files
- Updating 4
- Edit 1, 3, 4, 12-15, 17, using 4
- 18, 19, 20, 22, Installation 11
- 23, 24, 27-31,
- 36-38, 40, 42, J
- 44
- Edit Records 37 K
- EMS 12, 17, 18, 43
- Enter A Specific File 27 L
- Exit 1, 12, 17, 40, 46
- License 6, 9, 10
- F Registered Version
- License 10
- Field Shareware Version
- exclusive find in 31 License 9
- selection 30 Limitations 3
- Find Load order 43
- deleted records 35
- Exclusive 31 M
- Next 35
- Text 34 Memo fields
- Foxbase+ 1, 9, 44 searching 34
- FoxPro 1, 9, 44 Memory Consumption 12
- Frequent Database Access Memory Resident 1, 3, 11,
- 28 12, 13, 19, 20,
- 43
- G Modifying AUTOEXEC.BAT 12
- Move to
- H Current DOS Drive &
- Directory 28
- Help 3, 7, 11, 13, 21, Parent Directory 26
- 22, 29
-
-
- Copyright (c) 1989-91 Bowen Software Page 50
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Index
-
- N Quit 40, 46
- quit Edit and abort
- Network 4, 16, 18, 19, any changes 40
- 23, 26, 43, 45 quit Edit and save
- Number format 40
- configuration 47
- R
- O
- RAM Consumption 12
- Options 12-14, 16, 19, Registration 5, 6, 9
- 46, 48 for commercial and
- Ordering government 5
- form 5 How to Register 5
- How to 5 Registration Benefits
- using a credit card 6
- 5 registration fee 5
- Overview 1 Removing PopDBF from
- Memory 13, 19
- P Restore
- Entire Record 39
- Pack Database 34 Field Data 39
- Pass-Thru 3, 6, 11, 12, Running PopDBF
- 16, 17, 20 Memory Resident Mode
- Paste 1, 12, 37, 38, 40, 11
- 42, 46, 48 Non-Resident Mode 12
- changing frequency
- 48 S
- changing hotkey 48
- changing rate 48 Select Directory/File/Inde
- clearing buffer 38 x 26
- inside PopDBF 40 Setup View 30
- into underlying Shareware 1, 5-9
- application 37 Swap to Disk|EMS|None 17
- PC-FILE 1, 9 Swapping 12, 17-19
- Pick 3, 16, 22, 26, 27, specifying name of
- 30, 31, 42, 44 disk file 19
- Pick File 26 when to avoid 12
- Print
- File Structure 32 T
- from Browse 35
- from Edit 38 TapCIS 8
- Technical Support 8
- Q Toggle Keys 23
- Alt-C (Case) 23
- Questions and Answers 42 Alt-D (Borders) 23
- Quicksilver 1, 9 Alt-I (Insert) 23
-
- Copyright (c) 1989-91 Bowen Software Page 51
-
-
-
-
-
-
-
-
- PopDBF User's Manual
- Index
-
- Alt-M (Mode) 23
- TSR 43
- definition 1
-
- U
-
- V
-
- Verify Mode 40
- Viewing specific fields
- 30
-
- W
-
- Warranty 9, 10
- Wordstar commands 25
-
- X
-
- Y
-
- Z
-
- Zap Database 34
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Copyright (c) 1989-91 Bowen Software Page 52
-